package com.my.zl.console.service.online;

import com.my.zl.common.dto.ReqDTO;
import com.my.zl.common.dto.advancedQuery.PageQueryDTO;
import com.my.zl.console.entity.online.ZlDatabaseSql;
import com.my.zl.console.dto.online.databaseSql.ReqDatabaseSqlAddDTO;
import com.my.zl.console.dto.online.databaseSql.ReqDatabaseSqlDelDTO;
import com.my.zl.console.dto.online.databaseSql.ReqDatabaseSqlEditDTO;
import com.my.zl.console.dto.online.databaseSql.ReqDatabaseSqlQueryDTO;
import com.my.zl.console.dto.online.databaseSql.ReqDatabaseSqlDetailDTO;
import com.my.zl.console.dto.online.databaseSql.ReqDatabaseSqlStateDTO;
import com.my.zl.console.dto.online.databaseSql.ResDatabaseSqlAddDTO;
import com.my.zl.console.dto.online.databaseSql.ResDatabaseSqlDelDTO;
import com.my.zl.console.dto.online.databaseSql.ResDatabaseSqlEditDTO;
import com.my.zl.console.dto.online.databaseSql.ResDatabaseSqlQueryDTO;
import com.my.zl.console.dto.online.databaseSql.ResDatabaseSqlDetailDTO;
import com.my.zl.console.dto.online.databaseSql.ResDatabaseSqlStateDTO;

/**
 * 数据库模板
 * @author ZL
 */
public interface IDatabaseSqlService {

    /**
     * 查询
     */
    ResDatabaseSqlQueryDTO queryDatabaseSqlList(ReqDatabaseSqlQueryDTO reqInfo,PageQueryDTO page) throws Exception;
    
    /**
     * 详情
     */
    ResDatabaseSqlDetailDTO queryDatabaseSqlDetail(ReqDatabaseSqlDetailDTO reqInfo) throws Exception;
    
    /**
     * 新增
     */
    ResDatabaseSqlAddDTO insertDatabaseSqlInfo(ReqDTO<ReqDatabaseSqlAddDTO> reqInfo) throws Exception;
    
    /**
     * 编辑
     */
    ResDatabaseSqlEditDTO updateDatabaseSqlInfo(ReqDTO<ReqDatabaseSqlEditDTO> reqInfo) throws Exception;
    
    /**
     * 删除
     */
    ResDatabaseSqlDelDTO deleteDatabaseSqlInfo(ReqDTO<ReqDatabaseSqlDelDTO> reqInfo) throws Exception;
    
    /**
     * 更新状态
     */
    ResDatabaseSqlStateDTO updateDatabaseSqlState(ReqDTO<ReqDatabaseSqlStateDTO> reqInfo) throws Exception;
    
    
}